
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_MonHoc_UpdateMonHocByMaMH]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[sp_MonHoc_UpdateMonHocByMaMH]
GO
create procedure sp_MonHoc_UpdateMonHocByMaMH
	@MaMH varchar(10),
	@Ten_MH nvarchar(100),
	@Thoi_Gian_Bat_Dau varchar(40),	
	@Thoi_Gian_Ket_Thuc varchar(40),
	@Chung_Chi varchar(40),
	@Le_Phi varchar(40)
as
begin			
	UPDATE MonHoc 
	SET Ten_MH=@Ten_MH,
		Thoi_Gian_Bat_Dau=@Thoi_Gian_Bat_Dau,
		Thoi_Gian_Ket_Thuc=@Thoi_Gian_Ket_Thuc,
		Chung_chi=@Chung_Chi,
		Le_Phi=@Le_Phi	
	WHERE
		MaMH=@MaMH
end



